SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO




CREATE PROCEDURE [dbo].[usp_AddEmployee]
    (
      @JOL_Employee_Account VARCHAR(50),--账号
      @JOL_Employee_Password VARCHAR(50),--密码
      @JOL_Employee_Name VARCHAR(50),--姓名
      @JOL_Employee_Sex BIT,--性别
      @JOL_Employee_School VARCHAR(50),--学校
      @JOL_Employee_Profession VARCHAR(50),--专业
      @JOL_Employee_Longevity VARCHAR(50),--学历
      @JOL_Employee_StudyMethod VARCHAR(50),--学制
      @JOL_Employee_TrainMethod VARCHAR(50),--培养方式
      @JOL_Employee_StudyYearIn VARCHAR(50),--入学年份
      @JOL_Employee_StudyYearOut VARCHAR(50),--毕业年份
      @JOL_Employee_IDCardNo VARCHAR(50),--身份证号
      @JOL_Employee_Nation VARCHAR(50),--民族
      @JOL_Employee_Politics VARCHAR(50),--政治面貌
      @JOL_Employee_Province VARCHAR(50),--省份
      @JOL_Employee_Place VARCHAR(50),--生源地
      @JOL_Employee_TrainUnit VARCHAR(50),--委培单位
      @JOL_Employee_Mobile VARCHAR(50),--手机
      @JOL_Employee_Email VARCHAR(50),--邮箱
      @JOL_Employee_CredentialsFileLink VARCHAR(255),--证件路径
      @JOL_Employee_AddUser VARCHAR(50),--添加账户
      @JOL_Employee_VerifyStatus VARCHAR(50),
      @JOL_Employee_VerifyUser VARCHAR(50)
    )
AS 
    INSERT  INTO dbo.JOL_Employee
            (
              JOL_Employee_Account,
              JOL_Employee_Password,
              JOL_Employee_Name,
              JOL_Employee_Sex,
              JOL_Employee_School,
              JOL_Employee_Profession,
              JOL_Employee_Longevity,
              JOL_Employee_StudyMethod,
              JOL_Employee_TrainMethod,
              JOL_Employee_StudyYearIn,
              JOL_Employee_StudyYearOut,
              JOL_Employee_IDCardNo,
              JOL_Employee_Nation,
              JOL_Employee_Politics,
              JOL_Employee_Province,
              JOL_Employee_Place,
              JOL_Employee_TrainUnit,
              JOL_Employee_Mobile,
              JOL_Employee_Email,
              JOL_Employee_CredentialsFileLink,
              JOL_Employee_AddTime,
              JOL_Employee_AddUser,
              JOL_Employee_UpdateTime,
              JOL_Employee_UpdateUser,
              JOL_Employee_VerifyStatus,
              JOL_Employee_VerifyTime,
              JOL_Employee_VerifyUser,
              JOL_Employee_VerifyIsSendEmail
            )
    VALUES  (
              @JOL_Employee_Account, -- JOL_Employee_Account - varchar(50)
              @JOL_Employee_Password, -- JOL_Employee_Password - varchar(50)
              @JOL_Employee_Name, -- JOL_Employee_Name - varchar(50)
              @JOL_Employee_Sex, -- JOL_Employee_Sex - bit
              @JOL_Employee_School, -- JOL_Employee_School - varchar(50)
              @JOL_Employee_Profession, -- JOL_Employee_Profession - varchar(50)
              @JOL_Employee_Longevity, -- JOL_Employee_Longevity - varchar(50)
              @JOL_Employee_StudyMethod, -- JOL_Employee_StudyMethod - varchar(50)
              @JOL_Employee_TrainMethod, -- JOL_Employee_TrainMethod - varchar(50)
              @JOL_Employee_StudyYearIn, -- JOL_Employee_StudyYearIn - datetime
              @JOL_Employee_StudyYearOut, -- JOL_Employee_StudyYearOut - datetime
              @JOL_Employee_IDCardNo, -- JOL_Employee_IDCardNo - varchar(50)
              @JOL_Employee_Nation, -- JOL_Employee_Nation - varchar(50)
              @JOL_Employee_Politics, -- JOL_Employee_Politics - varchar(50)
              @JOL_Employee_Province,
              @JOL_Employee_Place, -- JOL_Employee_Place - varchar(50)
              @JOL_Employee_TrainUnit, -- JOL_Employee_TrainUnit - varchar(50)
              @JOL_Employee_Mobile, -- JOL_Employee_Mobile - varchar(50)
              @JOL_Employee_Email, -- JOL_Employee_Email - varchar(50)
              @JOL_Employee_CredentialsFileLink, -- JOL_Employee_CredentialsFileLink - varchar(255)
              GETDATE(), -- JOL_Employee_AddTime - datetime
              @JOL_Employee_AddUser, -- JOL_Employee_AddUser - varchar(50)
              NULL, -- JOL_Employee_UpdateTime - datetime
              NULL, -- JOL_Employee_UpdateUser - varchar(50)
              @JOL_Employee_VerifyStatus, -- JOL_Employee_VerifyStatus - varchar(50)
              CASE @JOL_Employee_VerifyStatus WHEN '已审核' THEN GETDATE() ELSE NULL END, -- JOL_Employee_VerifyTime - datetime
              NULL, -- JOL_Employee_VerifyUser - varchar(50)
              0  -- JOL_Employee_VerifyIsSendEmail - bit
            )




GO
